IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'CreatorsGet')
	BEGIN
		DROP  Procedure  CreatorsGet
	END

GO

CREATE Procedure CreatorsGet

AS
Select 
c.CreatorID,
c.DefaultSagaID,
c.IsBrowser,
c.CanAdd,
asp.UserName
From Creator c
Join aspnet_Users asp On asp.UserID = c.UserID



GO


